You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/Australia/Australia, 
MAX(IF(languagecode = 'en',name,NULL)) as eng, 
MAX(IF(la' at line 3Fehler mit Abfrage: <br>SELECT countryid, region1id, region2id, region3id, region4id, lat, lng, zip, COALESCE(it/Australia/Australia, eng, base) name FROM (
SELECT countryid, region1id, region2id, region3id, region4id, lat, lng, zip, 
MAX(IF(languagecode = 'it/Australia/Australia',name,NULL)) as it/Australia/Australia, 
MAX(IF(languagecode = 'en',name,NULL)) as eng, 
MAX(IF(languagecode = baselang,name,NULL)) as base 
FROM city c
inner JOIN city_languages cl ON c.idregion = cl.regionid
WHERE idregion = '493065' GROUP BY idregion )suby